﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace OneMake.Model
{
    //客服总绩效
    public class report_kf_detail
    {
        [MapToField(FieldName = "日期")]
        public DateTime stat_datetime { get; set; }

        [MapToField(FieldName = "旺旺昵称")]
        public string ww { get; set; }

        ////////////////ct_d_kfghzb
        [MapToExcel(ColumnName = "店铺")]
        public string kfghzb_shopname { get; set; }
        [MapToExcel(ColumnName = "分线")]
        public string kfghzb_fx { get; set; }
        [MapToExcel(ColumnName = "售前/售后")]
        public string kfghzb_sqsh { get; set; }
        [MapToExcel(ColumnName = "客服姓名")]
        public string kfghzb_kfname { get; set; }
        [MapToExcel(ColumnName = "是否挂号")]
        public string kfghzb_sfgh { get; set; }

        ////////////////ct_d_jxdb
        [MapToExcel(ColumnName = "接待人数")]
        public int jxdb_n_serve { get; set; }                    //  int(11) 	
        [MapToExcel(ColumnName = "询单人数")]
        public int jxdb_n_inquire { get; set; }                  //	int(11) 	
        [MapToExcel(ColumnName = "下单人数")]
        public int jxdb_n_ordered { get; set; }                  //	int(11) 	
        [MapToExcel(ColumnName = "付款人数")]
        public int jxdb_n_paid { get; set; }                     //	int(11) 	
        [MapToExcel(ColumnName = "下单金额")]
        public double jxdb_n_ordered_amount { get; set; }        //	double 	
        [MapToExcel(ColumnName = "付款金额")]
        public double jxdb_n_paid_amount { get; set; }            //	double 	
        [MapToExcel(ColumnName = "付款金额%")]
        public double jxdb_p_paid_amount { get; set; }           //	double 

        ////////////////ct_d_quire
        [MapToExcel(ColumnName = "询单人数")]
        public int quire_n_quire { get; set; }
        [MapToExcel(ColumnName = "流失人数")]
        public int quire_n_lost { get; set; }
        [MapToExcel(ColumnName = "当日下单人数")]
        public int quire_n_order { get; set; }
        [MapToExcel(ColumnName = "当日下单金额")]
        public double quire_n_order_amount { get; set; }
        [MapToExcel(ColumnName = "最终下单人数")]
        public int quire_n_final_order { get; set; }
        [MapToExcel(ColumnName = "最终下单金额")]
        public double quire_n_final_order_amount { get; set; }
        [MapToExcel(ColumnName = "成功率")]
        public double quire_per_success { get; set; }

        ////////////////ct_d_order
        [MapToExcel(ColumnName = "下单人数")]
        public int order_n_order { get; set; }
        [MapToExcel(ColumnName = "下单金额")]
        public double order_n_order_amount { get; set; }
        [MapToExcel(ColumnName = "流失人数")]
        public int order_n_lost { get; set; }
        [MapToExcel(ColumnName = "流失金额")]
        public double order_n_lost_amount { get; set; }
        [MapToExcel(ColumnName = "当日付款人数")]
        public int order_n_paid { get; set; }
        [MapToExcel(ColumnName = "当日付款金额")]
        public double order_n_paid_amount { get; set; }
        [MapToExcel(ColumnName = "最终付款人数")]
        public int order_n_final_paid { get; set; }
        [MapToExcel(ColumnName = "最终付款金额")]
        public double order_n_final_paid_amount { get; set; }
        [MapToExcel(ColumnName = "成功率")]
        public double order_per_success { get; set; }

        ////////////////ct_d_kdjdb
        [MapToExcel(ColumnName = "下单客单价")]
        public double kdjdb_uprice { get; set; }                  //	double 	
        [MapToExcel(ColumnName = "有效下单客单价")]
        public double kdjdb_valid_uprice { get; set; }            //	double 	
        [MapToExcel(ColumnName = "付款客单价")]
        public double kdjdb_paid_uprice { get; set; }             //	double 	

        ////////////////ct_d_kjsdb
        [MapToExcel(ColumnName = "下单件数")]
        public int kjsdb_n_order { get; set; }                //	int(11)
        [MapToExcel(ColumnName = "有效下单件数")]
        public int kjsdb_n_order_ok { get; set; }                //	int(11)
        [MapToExcel(ColumnName = "下单客件数")]
        public int kjsdb_n_unit { get; set; }                //	int(11)
        [MapToExcel(ColumnName = "有效下单客件数")]
        public int kjsdb_n_unit_ok { get; set; }                //	int(11)
        [MapToExcel(ColumnName = "下单件均价")]
        public int kjsdb_n_avg_price { get; set; }                //	int(11)
        [MapToExcel(ColumnName = "有效下单件均价")]
        public int kjsdb_n_avg_price_ok { get; set; }                //	int(11)

        ////////////////ct_d_cgldb
        [MapToExcel(ColumnName = "询单->当日下单成功率")]
        public double cgldb_per_iq_todayorder { get; set; }       //	double 	
        [MapToExcel(ColumnName = "询单->最终下单成功率")]
        public double cgldb_per_iq_finalorder { get; set; }       //	double 	
        [MapToExcel(ColumnName = "询单->最终付款成功率")]
        public double cgldb_per_iq_finalpaid { get; set; }        //	double 	
        [MapToExcel(ColumnName = "下单->当日付款成功率")]
        public double cgldb_per_todaypaid { get; set; }           //	double 	
        [MapToExcel(ColumnName = "下单->最终付款成功率")]
        public double cgldb_per_finalpaid { get; set; }           //	double 	

        ////////////////ct_d_gzldb
        [MapToExcel(ColumnName = "总接待")]
        public int gzldb_n_reception { get; set; }                //	int(11) 	
        [MapToExcel(ColumnName = "总消息数")]
        public int gzldb_n_msgs { get; set; }                     //	int(11) 	
        [MapToExcel(ColumnName = "买家消息数")]
        public int gzldb_n_customermsgs { get; set; }             //	int(11) 	
        [MapToExcel(ColumnName = "客服消息数")]
        public int gzldb_n_csmsgs { get; set; }                   //	int(11) 	
        [MapToExcel(ColumnName = "客服字数")]
        public int gzldb_n_cswords { get; set; }                  //	int(11) 	
        [MapToExcel(ColumnName = "最大同时接待数")]
        public int gzldb_n_maxreception { get; set; }             //	int(11) 	
        [MapToExcel(ColumnName = "旺旺回复率")]
        public double gzldb_per_wwreply { get; set; }             //	double 	
        [MapToExcel(ColumnName = "平均响应时间（秒）")]
        public int gzldb_avg_wwanswer { get; set; }               //	int(11) 	
        [MapToExcel(ColumnName = "首次响应时间（秒）")]
        public int gzldb_n_firstanswer { get; set; }              //	int(11) 		

        ////////////////ct_d_tkqkdb
        [MapToField(FieldName = "申请退款笔数")]
        public int tkqkdb_n_quit_count { get; set; }
        [MapToField(FieldName = "申请退款件数")]
        public int tkqkdb_n_quit_amount { get; set; }
        [MapToField(FieldName = "申请退款人数")]
        public int tkqkdb_n_quit_person { get; set; }
        [MapToField(FieldName = "申请退款金额")]
        public double tkqkdb_n_quit_money { get; set; }
        [MapToField(FieldName = "完成退款笔数")]
        public int tkqkdb_n_done_count { get; set; }
        [MapToField(FieldName = "完成退款件数")]
        public int tkqkdb_n_done_amount { get; set; }
        [MapToField(FieldName = "完成退款人数")]
        public int tkqkdb_n_done_person { get; set; }
        [MapToField(FieldName = "完成退款金额")]
        public double tkqkdb_n_done_money { get; set; }
        
        ////////////////ct_d_comment
        [MapToField(FieldName = "接待人数")]
        public int comment_n_recps { get; set; }
        [MapToField(FieldName = "发出评价数")]
        public int comment_n_send { get; set; }
        [MapToField(FieldName = "收到评价数")]
        public int comment_n_recv { get; set; }
        [MapToField(FieldName = "非常满意")]
        public int comment_n_rank_a { get; set; }
        [MapToField(FieldName = "比较满意")]
        public int comment_n_rank_b { get; set; }
        [MapToField(FieldName = "一般")]
        public int comment_n_rank_c { get; set; }
        [MapToField(FieldName = "不满意")]
        public int comment_n_rank_d { get; set; }
        [MapToField(FieldName = "评价发送率")]
        public double comment_per_send { get; set; }
        [MapToField(FieldName = "评价返回率")]
        public double comment_per_recv { get; set; }
        [MapToField(FieldName = "客户满意比")]
        public double comment_per_good { get; set; }
        [MapToField(FieldName = "客服服务满意度")]
        public double comment_n_good { get; set; }
    }
}
